Computer and Modernization ›› 2013, Vol. 1 ›› Issue (9): 229-231,.doi: 10.3969/j.issn.1006-2475.2013.09.056

• 应用与开发 • Previous Articles     Next Articles

Protecting Excel Files by Using VBA Program

LI Hua, GUO Jian-pu   

  1. Computer and Network Center, Communication University of China, Beijing 100024, China
  • Received:2013-03-22 Revised:1900-01-01 Online:2013-09-17 Published:2013-09-17

Abstract: For the problem of copyright and content protection of Excel documents, using VBA code, combining with the protective function of Excel, a more practical solution is provided from a technical point. In this scheme, user identity information is added to the original file with VBA program, and the file contents copy is forbidden. But the normal use of the file is not affected. The protection method for Excel file with VBA program can be also applied to other Office documents.

Key words: copy, original file, Office, copyright

CLC Number: